insert overwrite table yl_ods.yl_lmdm_sys_staff partition(dt)
select
id
,null as name
,cn_name
,en_name
,code
,country_id
,post_id
,post_name
,post_code
,scope_dispatch
,receiving_range
,null as contact_number
,township
,network_id
,network_name
,department_id
,department_name
,null as mobile
,null as telephone
,null as id_card
,null as extension_number
,null as phone
,is_real_name small
,is_enable small
,is_delete small
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,version
,sort small
,sex small
,null as email
,virtual_contracting_area_id
,virtual_contracting_area_code
,virtual_contracting_area_name
,type small
,ess_object small
,card_type small
,incumbency_status tiny
,is_delivery_ground tiny
,billing_weight
,dt
from jms_ods.yl_lmdm_sys_staff
where dt = '{{ execution_date | cst_ds }}' ;